This relational database template consists of the Projects file and the Project Tasks file. These two database files work together to keep track of projects and the specific tasks that need to be accomplished to complete each project. The Projects file keeps track of general information such as project name, status, description, milestones, and resources. The Project Tasks file contains details about the specific tasks, such as the task's status, cost, and headcount.
How to u
se this template
Start by defining the whole project in the Projects database. Then, name each task and fill out as much of the other information as you know. If you click the arrow button to the right of the task information, the Project Tasks database is opened and brought to the front. Finish filling out the task information, and then click the arrow button to the right of the Project Name to return to the Projects file.
How to customize this template
You can create custom reports to o
NotesB
InfoB
Created ByB
Last LayoutB
A List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Status
Finish
Start
Manager
Status
Finish
Start
Project Name
Enter data for Projects
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Resources &
Notes
Tasks
Projects
Tasks File...
Project ID
Project ReportB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Statusc
Finishd
Starte
Managerf
Project Nameg+Click to see more information for a Projectr
Infos
Closet
View As
Formu
View As
Listv
Reportsw
Recordx
Delete
Recordy
Recordz
Your Own
Button{
Your Own
Button|
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Description
Status
Finish
Start
Manager
Project
Page ##
Project Report
Close
View As
View As
Reports
Your Own
Button
Tasks
Project Report
Benefit Return
Notes
Report MenuB
P'Information about the Projects solutionQ
Info for this SolutionR
InfoS
CloseT
View As
FormU
View As
ListV
ReportsW
Your Own
Button
Your Own
ReportI
Your Own
ReportJ
Project ReportK
Your Own
ReportL>Click on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
Form View - Resources and NotesB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
[&Enter Resources and Notes for Projects
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Resources &
Notes
Tasks
Projects
Tasks File...
Benefit Return
Notes
Project ID
Project Name
Project Manager
Project Description
Start
Finish
Status
<2/1/96
Open Script
Sort by Project Name
Project Report
Open Script
<2/1/96
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Information
A List View
Report Menu
Sort by Project Start Date
Sort by Project Status
DDDDDD
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E+
) = 1
Information
List View
Report Menu
Sort by Project Name
Sort by Project Start Date
Sort by Project Status
Project Report
Open Script
Sort by Project Name
Project Report
Open Script
<2/1/96
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
/RPTH
FPTHA/SCSI Disk 20:JC:Ken's:COMPAT FUL:Project Tasks
Grganize the data. For instance, the report layout included in the Project Tasks file shows the tasks for each person on the team. You might want to organize the tasks by date or status.
If you have a regular team, you might want to use a value list to help you enter their names in the Task Manager and Project Manager fields.